package com.sanqi.work.mongomanager;

import java.util.Date;
import java.util.List;

import com.sanqi.work.mongodomain.WorkExcelInfo;

public interface IWorkExcelInfoManager {

    /**
     * @Description 保存excel信息
     * @param info
     * @return
     * Create at: 2025-10-14 16:46:33
     * @author: duany
     * Revision:
     *    2025-10-14 16:46:33 - first revision by duany
     *        
     */
    boolean saveInfo(WorkExcelInfo info);
    
    
    /**
     * @Description 删除明细
     * @param fileId 文件ID
     * @return
     * Create at: 2025-10-21 17:03:09
     * @author: duany
     * Revision:
     *    2025-10-21 17:03:09 - first revision by duany
     *        
     */
    boolean removeInfoByFileId(String fileId);


    /**
     * @Description 删除明细
     * @param fileId 文件ID
     * @param sheetName 窗口表格名称
     * Create at: 2025-10-22 09:00:15
     * @author: duany
     * Revision:
     *    2025-10-22 09:00:15 - first revision by duany
     *        
     */
    void removeInfoByFileIdSheetName(String fileId, String sheetName);


    /**
     * @Description 
     * @param fileId 文件ID
     * @param sheetName 窗口表格名称
     * @return
     * Create at: 2025-10-22 11:45:16
     * @author: duany
     * Revision:
     *    2025-10-22 11:45:16 - first revision by duany
     *        
     */
    List<WorkExcelInfo> getByFileIdSheetName(String fileId, String sheetName);


    List<WorkExcelInfo> getByFileId(String fileId);


    boolean updateById(WorkExcelInfo info);


    List<WorkExcelInfo> getByUser(String userId, Date beginDate, Date endDate);
    
    public List<WorkExcelInfo> getByUser(String userId, Date beginDate, Date endDate, String sheetName);
}
